2025-04-03 23:44:00,977 [ 699589 ] INFO : ClickHouse root is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse (runner:53, check_args_and_update_paths) 2025-04-03 23:44:00,977 [ 699589 ] INFO : Cases dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:97, check_args_and_update_paths) 2025-04-03 23:44:00,977 [ 699589 ] INFO : utils dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/utils (runner:108, check_args_and_update_paths) 2025-04-03 23:44:00,978 [ 699589 ] INFO : base_configs_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/programs/server, binary: /home/ubuntu/_work/_temp/test/build/clickhouse, cases_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:110, check_args_and_update_paths) clickhouse_integration_tests_volume Running pytest container as: 'docker run --rm --name clickhouse_integration_tests_qiz37x --privileged --dns-search='.' --memory=30709039104 --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=5dc43a6382f0 -e DOCKER_BASE_TAG=6712d5cc610d -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=caad4729259e -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_select_access_rights/test_main.py::test_select_with_row_policy test_server_initialization/test.py::test_partially_dropped_tables test_server_initialization/test.py::test_sophisticated_default test_server_start_and_ip_conversions/test.py::test_restart_success_ipv4 test_server_start_and_ip_conversions/test.py::test_restart_success_ipv6 test_settings_constraints/test.py::test_max_constraint test_settings_constraints/test.py::test_min_constraint test_settings_constraints/test.py::test_read_only_constraint test_settings_constraints/test.py::test_system_constraints test_settings_constraints/test.py::test_system_settings test_settings_from_server/test.py::test_settings_from_server test_settings_randomization/test.py::test_settings_randomization test_sharding_key_from_default_column/test.py::test_default_column test_sharding_key_from_default_column/test.py::test_materialized_column_allow_insert_materialized test_sharding_key_from_default_column/test.py::test_materialized_column_disallow_insert_materialized test_sharding_key_from_default_column/test.py::test_materialized_column_disallow_insert_materialized_different_shards test_startup_scripts/test.py::test_startup_scripts test_startup_scripts_execution_state/test.py::test_startup_execution_state test_stop_insert_when_disk_close_to_full/test.py::test_insert_stops_when_disk_full test_stop_insert_when_disk_close_to_full/test.py::test_min_free_disk_settings test_storage_azure_blob_storage/test.py::test_azure_glob_scheherazade test_storage_azure_blob_storage/test.py::test_create_new_files_on_insert test_storage_azure_blob_storage/test.py::test_create_table_account_string test_storage_azure_blob_storage/test.py::test_create_table_connection_string test_storage_azure_blob_storage/test.py::test_filter_using_file test_storage_azure_blob_storage/test.py::test_filtering_by_file_or_path test_storage_azure_blob_storage/test.py::test_format_detection test_storage_azure_blob_storage/test.py::test_function_signatures test_storage_azure_blob_storage/test.py::test_hive_partitioning_with_all_parameters test_storage_azure_blob_storage/test.py::test_hive_partitioning_with_one_parameter test_storage_azure_blob_storage/test.py::test_hive_partitioning_without_setting test_storage_azure_blob_storage/test.py::test_insert_create_new_file test_storage_azure_blob_storage/test.py::test_insert_with_path_with_globs test_storage_azure_blob_storage/test.py::test_overwrite test_storage_azure_blob_storage/test.py::test_parallel_read test_storage_azure_blob_storage/test.py::test_partition_by test_storage_azure_blob_storage/test.py::test_partition_by_const_column test_storage_azure_blob_storage/test.py::test_partition_by_string_column test_storage_azure_blob_storage/test.py::test_partition_by_tf test_storage_azure_blob_storage/test.py::test_put_get_with_globs test_storage_azure_blob_storage/test.py::test_put_get_with_globs_tf test_storage_azure_blob_storage/test.py::test_read_from_not_existing_container test_storage_azure_blob_storage/test.py::test_read_subcolumn_time test_storage_azure_blob_storage/test.py::test_read_subcolumns test_storage_azure_blob_storage/test.py::test_respect_object_existence_on_partitioned_write test_storage_azure_blob_storage/test.py::test_schema_inference_cache test_storage_azure_blob_storage/test.py::test_schema_inference_from_globs test_storage_azure_blob_storage/test.py::test_schema_inference_from_globs_tf test_storage_azure_blob_storage/test.py::test_schema_inference_no_globs test_storage_azure_blob_storage/test.py::test_schema_inference_no_globs_tf test_storage_azure_blob_storage/test.py::test_simple_read_write test_storage_azure_blob_storage/test.py::test_simple_write_account_string test_storage_azure_blob_storage/test.py::test_simple_write_account_string_table_function test_storage_azure_blob_storage/test.py::test_simple_write_connection_string test_storage_azure_blob_storage/test.py::test_simple_write_connection_string_table_function test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_1 test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_1_table_function test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_2 test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_2_table_function test_storage_azure_blob_storage/test.py::test_size_virtual_column 'test_storage_azure_blob_storage/test.py::test_storage_azure_get_gzip[bin]' 'test_storage_azure_blob_storage/test.py::test_storage_azure_get_gzip[gz]' test_storage_azure_blob_storage/test.py::test_truncate test_storage_azure_blob_storage/test.py::test_union_schema_inference_mode test_storage_azure_blob_storage/test.py::test_write_to_globbed_partitioned_path 'test_storage_mongodb_legacy/test.py::test_arrays[False]' 'test_storage_mongodb_legacy/test.py::test_auth_source[False]' 'test_storage_mongodb_legacy/test.py::test_complex_data_type[False]' 'test_storage_mongodb_legacy/test.py::test_incorrect_data_type[False]' 'test_storage_mongodb_legacy/test.py::test_missing_columns[False]' 'test_storage_mongodb_legacy/test.py::test_no_credentials[False]' 'test_storage_mongodb_legacy/test.py::test_predefined_connection_configuration[False]' 'test_storage_mongodb_legacy/test.py::test_secure_connection[True]' 'test_storage_mongodb_legacy/test.py::test_simple_insert_select[False]' 'test_storage_mongodb_legacy/test.py::test_simple_select[False]' 'test_storage_mongodb_legacy/test.py::test_simple_select_from_view[False]' 'test_storage_mongodb_legacy/test.py::test_uuid[False]' test_storage_mysql/test.py::test_binary_type test_storage_mysql/test.py::test_enum_type test_storage_mysql/test.py::test_external_settings test_storage_mysql/test.py::test_insert_on_duplicate_select test_storage_mysql/test.py::test_insert_select test_storage_mysql/test.py::test_joins test_storage_mysql/test.py::test_many_connections test_storage_mysql/test.py::test_mysql_in test_storage_mysql/test.py::test_mysql_null test_storage_mysql/test.py::test_mysql_point test_storage_mysql/test.py::test_predefined_connection_configuration test_storage_mysql/test.py::test_replace_select test_storage_mysql/test.py::test_schema_inference test_storage_mysql/test.py::test_settings test_storage_mysql/test.py::test_settings_connection_wait_timeout test_storage_mysql/test.py::test_table_function test_storage_mysql/test.py::test_where test_storage_policies/test.py::test_storage_policy_configuration_change test_storage_postgresql/test.py::test_auto_close_connection test_storage_postgresql/test.py::test_concurrent_queries test_storage_postgresql/test.py::test_datetime64 test_storage_postgresql/test.py::test_datetime_with_timezone test_storage_postgresql/test.py::test_filter_pushdown -vvv" altinityinfra/integration-tests-runner:cd6390247eca '. Start tests ============================= test session starts ============================== platform linux -- Python 3.10.12, pytest-7.4.4, pluggy-1.5.0 -- /usr/bin/python3 cachedir: .pytest_cache rootdir: /ClickHouse/tests/integration configfile: pytest.ini plugins: random-0.2, timeout-2.2.0, repeat-0.9.3, order-1.0.0, reportlog-0.4.0, xdist-3.5.0 timeout: 900.0s timeout method: signal timeout func_only: False created: 10/10 workers 10 workers [100 items] scheduling tests via LoadFileScheduling test_storage_azure_blob_storage/test.py::test_azure_glob_scheherazade test_storage_mysql/test.py::test_binary_type test_server_initialization/test.py::test_partially_dropped_tables test_storage_mongodb_legacy/test.py::test_arrays[False] test_settings_constraints/test.py::test_max_constraint test_server_start_and_ip_conversions/test.py::test_restart_success_ipv4 test_storage_postgresql/test.py::test_auto_close_connection test_stop_insert_when_disk_close_to_full/test.py::test_insert_stops_when_disk_full test_sharding_key_from_default_column/test.py::test_default_column test_select_access_rights/test_main.py::test_select_with_row_policy [gw3] [ 1%] PASSED test_settings_constraints/test.py::test_max_constraint test_settings_constraints/test.py::test_min_constraint [gw8] [ 2%] PASSED test_select_access_rights/test_main.py::test_select_with_row_policy [gw3] [ 3%] PASSED test_settings_constraints/test.py::test_min_constraint test_settings_constraints/test.py::test_read_only_constraint [gw3] [ 4%] PASSED test_settings_constraints/test.py::test_read_only_constraint test_settings_constraints/test.py::test_system_constraints [gw3] [ 5%] PASSED test_settings_constraints/test.py::test_system_constraints test_settings_constraints/test.py::test_system_settings [gw3] [ 6%] PASSED test_settings_constraints/test.py::test_system_settings [gw7] [ 7%] PASSED test_server_start_and_ip_conversions/test.py::test_restart_success_ipv4 test_server_start_and_ip_conversions/test.py::test_restart_success_ipv6 [gw5] [ 8%] PASSED test_storage_postgresql/test.py::test_auto_close_connection test_storage_postgresql/test.py::test_concurrent_queries test_startup_scripts_execution_state/test.py::test_startup_execution_state [gw9] [ 9%] PASSED test_stop_insert_when_disk_close_to_full/test.py::test_insert_stops_when_disk_full test_stop_insert_when_disk_close_to_full/test.py::test_min_free_disk_settings test_storage_policies/test.py::test_storage_policy_configuration_change [gw4] [ 10%] PASSED test_sharding_key_from_default_column/test.py::test_default_column test_sharding_key_from_default_column/test.py::test_materialized_column_allow_insert_materialized [gw9] [ 11%] PASSED test_stop_insert_when_disk_close_to_full/test.py::test_min_free_disk_settings [gw7] [ 12%] PASSED test_server_start_and_ip_conversions/test.py::test_restart_success_ipv6 [gw4] [ 13%] PASSED test_sharding_key_from_default_column/test.py::test_materialized_column_allow_insert_materialized test_sharding_key_from_default_column/test.py::test_materialized_column_disallow_insert_materialized test_settings_randomization/test.py::test_settings_randomization test_startup_scripts/test.py::test_startup_scripts [gw4] [ 14%] PASSED test_sharding_key_from_default_column/test.py::test_materialized_column_disallow_insert_materialized test_sharding_key_from_default_column/test.py::test_materialized_column_disallow_insert_materialized_different_shards [gw4] [ 15%] PASSED test_sharding_key_from_default_column/test.py::test_materialized_column_disallow_insert_materialized_different_shards [gw7] [ 16%] FAILED test_settings_randomization/test.py::test_settings_randomization [gw8] [ 17%] PASSED test_startup_scripts_execution_state/test.py::test_startup_execution_state [gw5] [ 18%] PASSED test_storage_postgresql/test.py::test_concurrent_queries test_storage_postgresql/test.py::test_datetime64 [gw5] [ 19%] PASSED test_storage_postgresql/test.py::test_datetime64 test_storage_postgresql/test.py::test_datetime_with_timezone [gw6] [ 20%] PASSED test_server_initialization/test.py::test_partially_dropped_tables test_server_initialization/test.py::test_sophisticated_default [gw5] [ 21%] PASSED test_storage_postgresql/test.py::test_datetime_with_timezone test_storage_postgresql/test.py::test_filter_pushdown [gw6] [ 22%] PASSED test_server_initialization/test.py::test_sophisticated_default [gw2] [ 23%] PASSED test_storage_mongodb_legacy/test.py::test_arrays[False] test_storage_mongodb_legacy/test.py::test_auth_source[False] [gw2] [ 24%] PASSED test_storage_mongodb_legacy/test.py::test_auth_source[False] test_storage_mongodb_legacy/test.py::test_complex_data_type[False] test_settings_from_server/test.py::test_settings_from_server [gw2] [ 25%] PASSED test_storage_mongodb_legacy/test.py::test_complex_data_type[False] test_storage_mongodb_legacy/test.py::test_incorrect_data_type[False] [gw2] [ 26%] PASSED test_storage_mongodb_legacy/test.py::test_incorrect_data_type[False] test_storage_mongodb_legacy/test.py::test_missing_columns[False] [gw2] [ 27%] PASSED test_storage_mongodb_legacy/test.py::test_missing_columns[False] test_storage_mongodb_legacy/test.py::test_no_credentials[False] [gw2] [ 28%] PASSED test_storage_mongodb_legacy/test.py::test_no_credentials[False] test_storage_mongodb_legacy/test.py::test_predefined_connection_configuration[False] [gw2] [ 29%] PASSED test_storage_mongodb_legacy/test.py::test_predefined_connection_configuration[False] test_storage_mongodb_legacy/test.py::test_secure_connection[True] [gw1] [ 30%] PASSED test_storage_mysql/test.py::test_binary_type test_storage_mysql/test.py::test_enum_type [gw5] [ 31%] PASSED test_storage_postgresql/test.py::test_filter_pushdown [gw1] [ 32%] PASSED test_storage_mysql/test.py::test_enum_type test_storage_mysql/test.py::test_external_settings [gw3] [ 33%] PASSED test_storage_policies/test.py::test_storage_policy_configuration_change [gw1] [ 34%] PASSED test_storage_mysql/test.py::test_external_settings test_storage_mysql/test.py::test_insert_on_duplicate_select [gw6] [ 35%] PASSED test_settings_from_server/test.py::test_settings_from_server [gw1] [ 36%] PASSED test_storage_mysql/test.py::test_insert_on_duplicate_select test_storage_mysql/test.py::test_insert_select [gw1] [ 37%] PASSED test_storage_mysql/test.py::test_insert_select test_storage_mysql/test.py::test_joins [gw1] [ 38%] PASSED test_storage_mysql/test.py::test_joins test_storage_mysql/test.py::test_many_connections [gw1] [ 39%] PASSED test_storage_mysql/test.py::test_many_connections test_storage_mysql/test.py::test_mysql_in [gw9] [ 40%] PASSED test_startup_scripts/test.py::test_startup_scripts [gw1] [ 41%] PASSED test_storage_mysql/test.py::test_mysql_in test_storage_mysql/test.py::test_mysql_null [gw1] [ 42%] PASSED test_storage_mysql/test.py::test_mysql_null test_storage_mysql/test.py::test_mysql_point [gw1] [ 43%] PASSED test_storage_mysql/test.py::test_mysql_point test_storage_mysql/test.py::test_predefined_connection_configuration [gw1] [ 44%] PASSED test_storage_mysql/test.py::test_predefined_connection_configuration test_storage_mysql/test.py::test_replace_select [gw1] [ 45%] PASSED test_storage_mysql/test.py::test_replace_select test_storage_mysql/test.py::test_schema_inference [gw1] [ 46%] PASSED test_storage_mysql/test.py::test_schema_inference test_storage_mysql/test.py::test_settings [gw1] [ 47%] PASSED test_storage_mysql/test.py::test_settings test_storage_mysql/test.py::test_settings_connection_wait_timeout [gw1] [ 48%] PASSED test_storage_mysql/test.py::test_settings_connection_wait_timeout test_storage_mysql/test.py::test_table_function [gw1] [ 49%] PASSED test_storage_mysql/test.py::test_table_function test_storage_mysql/test.py::test_where [gw1] [ 50%] PASSED test_storage_mysql/test.py::test_where [gw2] [ 51%] PASSED test_storage_mongodb_legacy/test.py::test_secure_connection[True] test_storage_mongodb_legacy/test.py::test_simple_insert_select[False] [gw2] [ 52%] PASSED test_storage_mongodb_legacy/test.py::test_simple_insert_select[False] test_storage_mongodb_legacy/test.py::test_simple_select[False] [gw2] [ 53%] PASSED test_storage_mongodb_legacy/test.py::test_simple_select[False] test_storage_mongodb_legacy/test.py::test_simple_select_from_view[False] [gw2] [ 54%] PASSED test_storage_mongodb_legacy/test.py::test_simple_select_from_view[False] test_storage_mongodb_legacy/test.py::test_uuid[False] [gw2] [ 55%] PASSED test_storage_mongodb_legacy/test.py::test_uuid[False] [gw0] [ 56%] PASSED test_storage_azure_blob_storage/test.py::test_azure_glob_scheherazade test_storage_azure_blob_storage/test.py::test_create_new_files_on_insert [gw0] [ 57%] PASSED test_storage_azure_blob_storage/test.py::test_create_new_files_on_insert test_storage_azure_blob_storage/test.py::test_create_table_account_string [gw0] [ 58%] PASSED test_storage_azure_blob_storage/test.py::test_create_table_account_string test_storage_azure_blob_storage/test.py::test_create_table_connection_string [gw0] [ 59%] PASSED test_storage_azure_blob_storage/test.py::test_create_table_connection_string test_storage_azure_blob_storage/test.py::test_filter_using_file [gw0] [ 60%] PASSED test_storage_azure_blob_storage/test.py::test_filter_using_file test_storage_azure_blob_storage/test.py::test_filtering_by_file_or_path [gw0] [ 61%] PASSED test_storage_azure_blob_storage/test.py::test_filtering_by_file_or_path test_storage_azure_blob_storage/test.py::test_format_detection [gw0] [ 62%] PASSED test_storage_azure_blob_storage/test.py::test_format_detection test_storage_azure_blob_storage/test.py::test_function_signatures [gw0] [ 63%] PASSED test_storage_azure_blob_storage/test.py::test_function_signatures test_storage_azure_blob_storage/test.py::test_hive_partitioning_with_all_parameters [gw0] [ 64%] PASSED test_storage_azure_blob_storage/test.py::test_hive_partitioning_with_all_parameters test_storage_azure_blob_storage/test.py::test_hive_partitioning_with_one_parameter [gw0] [ 65%] PASSED test_storage_azure_blob_storage/test.py::test_hive_partitioning_with_one_parameter test_storage_azure_blob_storage/test.py::test_hive_partitioning_without_setting [gw0] [ 66%] PASSED test_storage_azure_blob_storage/test.py::test_hive_partitioning_without_setting test_storage_azure_blob_storage/test.py::test_insert_create_new_file [gw0] [ 67%] PASSED test_storage_azure_blob_storage/test.py::test_insert_create_new_file test_storage_azure_blob_storage/test.py::test_insert_with_path_with_globs [gw0] [ 68%] PASSED test_storage_azure_blob_storage/test.py::test_insert_with_path_with_globs test_storage_azure_blob_storage/test.py::test_overwrite [gw0] [ 69%] PASSED test_storage_azure_blob_storage/test.py::test_overwrite test_storage_azure_blob_storage/test.py::test_parallel_read [gw0] [ 70%] PASSED test_storage_azure_blob_storage/test.py::test_parallel_read test_storage_azure_blob_storage/test.py::test_partition_by [gw0] [ 71%] PASSED test_storage_azure_blob_storage/test.py::test_partition_by test_storage_azure_blob_storage/test.py::test_partition_by_const_column [gw0] [ 72%] PASSED test_storage_azure_blob_storage/test.py::test_partition_by_const_column test_storage_azure_blob_storage/test.py::test_partition_by_string_column [gw0] [ 73%] PASSED test_storage_azure_blob_storage/test.py::test_partition_by_string_column test_storage_azure_blob_storage/test.py::test_partition_by_tf [gw0] [ 74%] PASSED test_storage_azure_blob_storage/test.py::test_partition_by_tf test_storage_azure_blob_storage/test.py::test_put_get_with_globs [gw0] [ 75%] PASSED test_storage_azure_blob_storage/test.py::test_put_get_with_globs test_storage_azure_blob_storage/test.py::test_put_get_with_globs_tf [gw0] [ 76%] PASSED test_storage_azure_blob_storage/test.py::test_put_get_with_globs_tf test_storage_azure_blob_storage/test.py::test_read_from_not_existing_container [gw0] [ 77%] PASSED test_storage_azure_blob_storage/test.py::test_read_from_not_existing_container test_storage_azure_blob_storage/test.py::test_read_subcolumn_time [gw0] [ 78%] PASSED test_storage_azure_blob_storage/test.py::test_read_subcolumn_time test_storage_azure_blob_storage/test.py::test_read_subcolumns [gw0] [ 79%] PASSED test_storage_azure_blob_storage/test.py::test_read_subcolumns test_storage_azure_blob_storage/test.py::test_respect_object_existence_on_partitioned_write [gw0] [ 80%] PASSED test_storage_azure_blob_storage/test.py::test_respect_object_existence_on_partitioned_write test_storage_azure_blob_storage/test.py::test_schema_inference_cache [gw0] [ 81%] PASSED test_storage_azure_blob_storage/test.py::test_schema_inference_cache test_storage_azure_blob_storage/test.py::test_schema_inference_from_globs [gw0] [ 82%] PASSED test_storage_azure_blob_storage/test.py::test_schema_inference_from_globs test_storage_azure_blob_storage/test.py::test_schema_inference_from_globs_tf [gw0] [ 83%] PASSED test_storage_azure_blob_storage/test.py::test_schema_inference_from_globs_tf test_storage_azure_blob_storage/test.py::test_schema_inference_no_globs [gw0] [ 84%] PASSED test_storage_azure_blob_storage/test.py::test_schema_inference_no_globs test_storage_azure_blob_storage/test.py::test_schema_inference_no_globs_tf [gw0] [ 85%] PASSED test_storage_azure_blob_storage/test.py::test_schema_inference_no_globs_tf test_storage_azure_blob_storage/test.py::test_simple_read_write [gw0] [ 86%] PASSED test_storage_azure_blob_storage/test.py::test_simple_read_write test_storage_azure_blob_storage/test.py::test_simple_write_account_string [gw0] [ 87%] PASSED test_storage_azure_blob_storage/test.py::test_simple_write_account_string test_storage_azure_blob_storage/test.py::test_simple_write_account_string_table_function [gw0] [ 88%] PASSED test_storage_azure_blob_storage/test.py::test_simple_write_account_string_table_function test_storage_azure_blob_storage/test.py::test_simple_write_connection_string [gw0] [ 89%] PASSED test_storage_azure_blob_storage/test.py::test_simple_write_connection_string test_storage_azure_blob_storage/test.py::test_simple_write_connection_string_table_function [gw0] [ 90%] PASSED test_storage_azure_blob_storage/test.py::test_simple_write_connection_string_table_function test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_1 [gw0] [ 91%] PASSED test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_1 test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_1_table_function [gw0] [ 92%] PASSED test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_1_table_function test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_2 [gw0] [ 93%] PASSED test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_2 test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_2_table_function [gw0] [ 94%] PASSED test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_2_table_function test_storage_azure_blob_storage/test.py::test_size_virtual_column [gw0] [ 95%] PASSED test_storage_azure_blob_storage/test.py::test_size_virtual_column test_storage_azure_blob_storage/test.py::test_storage_azure_get_gzip[bin] [gw0] [ 96%] PASSED test_storage_azure_blob_storage/test.py::test_storage_azure_get_gzip[bin] test_storage_azure_blob_storage/test.py::test_storage_azure_get_gzip[gz] [gw0] [ 97%] PASSED test_storage_azure_blob_storage/test.py::test_storage_azure_get_gzip[gz] test_storage_azure_blob_storage/test.py::test_truncate [gw0] [ 98%] PASSED test_storage_azure_blob_storage/test.py::test_truncate test_storage_azure_blob_storage/test.py::test_union_schema_inference_mode [gw0] [ 99%] PASSED test_storage_azure_blob_storage/test.py::test_union_schema_inference_mode test_storage_azure_blob_storage/test.py::test_write_to_globbed_partitioned_path [gw0] [100%] PASSED test_storage_azure_blob_storage/test.py::test_write_to_globbed_partitioned_path =================================== FAILURES =================================== _________________________ test_settings_randomization __________________________ [gw7] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_settings_randomization(started_cluster): """ See tests/integration/helpers/random_settings.py """ def q(field, name): return int( node.query( f"SELECT {field} FROM system.settings WHERE name = '{name}'" ).strip() ) # setting set in test config is not overriden assert q("value", "max_block_size") == 59999 # some setting is randomized > assert q("changed", "max_joined_block_size_rows") == 1 E AssertionError: assert 0 == 1 E + where 0 = .q at 0x7fc236de6170>('changed', 'max_joined_block_size_rows') test_settings_randomization/test.py:35: AssertionError ---------------------------- Captured stdout setup ----------------------------- Copy common default production configuration from /clickhouse-config. Files: config.xml, users.xml ------------------------------ Captured log setup ------------------------------ 2025-04-03 23:44:30 [ 719 ] INFO : Running tests in /ClickHouse/tests/integration/test_settings_randomization/test.py (cluster.py:2793, start) 2025-04-03 23:44:30 [ 719 ] DEBUG : Cluster start called. is_up=False (cluster.py:2800, start) 2025-04-03 23:44:30 [ 719 ] DEBUG : Docker networks for project roottestsettingsrandomization-gw7 are NETWORK ID NAME DRIVER SCOPE (cluster.py:873, print_all_docker_pieces) 2025-04-03 23:44:30 [ 719 ] DEBUG : Docker containers for project roottestsettingsrandomization-gw7 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:881, print_all_docker_pieces) 2025-04-03 23:44:30 [ 719 ] DEBUG : Docker volumes for project roottestsettingsrandomization-gw7 are DRIVER VOLUME NAME (cluster.py:889, print_all_docker_pieces) 2025-04-03 23:44:30 [ 719 ] DEBUG : Cleanup called (cluster.py:894, cleanup) 2025-04-03 23:44:30 [ 719 ] DEBUG : Docker networks for project roottestsettingsrandomization-gw7 are NETWORK ID NAME DRIVER SCOPE (cluster.py:873, print_all_docker_pieces) 2025-04-03 23:44:30 [ 719 ] DEBUG : Docker containers for project roottestsettingsrandomization-gw7 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:881, print_all_docker_pieces) 2025-04-03 23:44:30 [ 719 ] DEBUG : Docker volumes for project roottestsettingsrandomization-gw7 are DRIVER VOLUME NAME (cluster.py:889, print_all_docker_pieces) 2025-04-03 23:44:30 [ 719 ] DEBUG : Command:[docker container list --all --filter name='^/roottestsettingsrandomization-gw7-.*-1$' --format '{{.ID}}:{{.Names}}'] (cluster.py:122, run_and_check) 2025-04-03 23:44:30 [ 719 ] DEBUG : Unstopped containers: {} (cluster.py:908, cleanup) 2025-04-03 23:44:30 [ 719 ] DEBUG : No running containers for project: roottestsettingsrandomization-gw7 (cluster.py:922, cleanup) 2025-04-03 23:44:30 [ 719 ] DEBUG : Trying to prune unused networks... (cluster.py:928, cleanup) 2025-04-03 23:44:30 [ 719 ] DEBUG : Trying to prune unused images... (cluster.py:944, cleanup) 2025-04-03 23:44:30 [ 719 ] DEBUG : Command:[docker image prune -f] (cluster.py:122, run_and_check) 2025-04-03 23:44:30 [ 719 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:146, run_and_check) 2025-04-03 23:44:30 [ 719 ] DEBUG : Images pruned (cluster.py:947, cleanup) 2025-04-03 23:44:30 [ 719 ] DEBUG : Trying to prune unused volumes... (cluster.py:953, cleanup) 2025-04-03 23:44:30 [ 719 ] DEBUG : Command:[docker volume ls | wc -l] (cluster.py:122, run_and_check) 2025-04-03 23:44:30 [ 719 ] DEBUG : Stdout:15 (cluster.py:146, run_and_check) 2025-04-03 23:44:30 [ 719 ] DEBUG : Command:[docker volume prune -f] (cluster.py:122, run_and_check) 2025-04-03 23:44:30 [ 719 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:146, run_and_check) 2025-04-03 23:44:30 [ 719 ] DEBUG : Volumes pruned: 15 (cluster.py:958, cleanup) 2025-04-03 23:44:30 [ 719 ] DEBUG : Setup directory for instance: node1 (cluster.py:2813, start) 2025-04-03 23:44:30 [ 719 ] DEBUG : Create directory for configuration generated in this helper (cluster.py:4639, create_dir) 2025-04-03 23:44:30 [ 719 ] DEBUG : Create directory for common tests configuration (cluster.py:4644, create_dir) 2025-04-03 23:44:30 [ 719 ] DEBUG : Copy common configuration from helpers (cluster.py:4664, create_dir) 2025-04-03 23:44:30 [ 719 ] DEBUG : Generate and write macros file (cluster.py:4716, create_dir) 2025-04-03 23:44:30 [ 719 ] DEBUG : Copy custom test config files [] to /ClickHouse/tests/integration/test_settings_randomization/_instances-0-gw7/node1/configs/config.d (cluster.py:4752, create_dir) 2025-04-03 23:44:30 [ 719 ] DEBUG : Setup database dir /ClickHouse/tests/integration/test_settings_randomization/_instances-0-gw7/node1/database (cluster.py:4769, create_dir) 2025-04-03 23:44:30 [ 719 ] DEBUG : Setup logs dir /ClickHouse/tests/integration/test_settings_randomization/_instances-0-gw7/node1/logs (cluster.py:4780, create_dir) 2025-04-03 23:44:30 [ 719 ] DEBUG : Entrypoint cmd: ["clickhouse", "server", "--config-file=/etc/clickhouse-server/config.xml", "--log-file=/var/log/clickhouse-server/clickhouse-server.log", "--errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log", "--"] (cluster.py:4864, create_dir) 2025-04-03 23:44:30 [ 719 ] DEBUG : Env {'ASAN_OPTIONS': 'use_sigaltstack=0', 'TSAN_OPTIONS': 'use_sigaltstack=0', 'CLICKHOUSE_WATCHDOG_ENABLE': '0', 'CLICKHOUSE_NATS_TLS_SECURE': '0', 'LLVM_PROFILE_FILE': '/var/lib/clickhouse/server_%h_%p_%m.profraw'} stored in /ClickHouse/tests/integration/test_settings_randomization/_instances-0-gw7/.env (cluster.py:97, _create_env_file) 2025-04-03 23:44:30 [ 719 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-04-03 23:44:30 [ 719 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-04-03 23:44:30 [ 719 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-04-03 23:44:30 [ 719 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-04-03 23:44:30 [ 719 ] DEBUG : http://localhost:None "GET /version HTTP/1.1" 200 826 (connectionpool.py:547, _make_request) 2025-04-03 23:44:30 [ 719 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_settings_randomization/_instances-0-gw7/.env --project-name roottestsettingsrandomization-gw7 --file /ClickHouse/tests/integration/test_settings_randomization/_instances-0-gw7/node1/docker-compose.yml pull] (cluster.py:122, run_and_check) 2025-04-03 23:44:31 [ 719 ] DEBUG : Stderr: node1 Pulling (cluster.py:148, run_and_check) 2025-04-03 23:44:31 [ 719 ] DEBUG : Stderr: node1 Pulled (cluster.py:148, run_and_check) 2025-04-03 23:44:31 [ 719 ] DEBUG : ('Trying to create ClickHouse instance by command %s', 'docker compose --env-file /ClickHouse/tests/integration/test_settings_randomization/_instances-0-gw7/.env --project-name roottestsettingsrandomization-gw7 --file /ClickHouse/tests/integration/test_settings_randomization/_instances-0-gw7/node1/docker-compose.yml up -d --no-recreate') (cluster.py:3200, start) 2025-04-03 23:44:31 [ 719 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_settings_randomization/_instances-0-gw7/.env --project-name roottestsettingsrandomization-gw7 --file /ClickHouse/tests/integration/test_settings_randomization/_instances-0-gw7/node1/docker-compose.yml up -d --no-recreate] (cluster.py:122, run_and_check) 2025-04-03 23:44:32 [ 719 ] DEBUG : Stderr: Network roottestsettingsrandomization-gw7_default Creating (cluster.py:148, run_and_check) 2025-04-03 23:44:32 [ 719 ] DEBUG : Stderr: Network roottestsettingsrandomization-gw7_default Created (cluster.py:148, run_and_check) 2025-04-03 23:44:32 [ 719 ] DEBUG : Stderr: Container roottestsettingsrandomization-gw7-node1-1 Creating (cluster.py:148, run_and_check) 2025-04-03 23:44:32 [ 719 ] DEBUG : Stderr: Container roottestsettingsrandomization-gw7-node1-1 Created (cluster.py:148, run_and_check) 2025-04-03 23:44:32 [ 719 ] DEBUG : Stderr: Container roottestsettingsrandomization-gw7-node1-1 Starting (cluster.py:148, run_and_check) 2025-04-03 23:44:32 [ 719 ] DEBUG : Stderr: Container roottestsettingsrandomization-gw7-node1-1 Started (cluster.py:148, run_and_check) 2025-04-03 23:44:32 [ 719 ] DEBUG : ClickHouse instance created (cluster.py:3208, start) 2025-04-03 23:44:32 [ 719 ] DEBUG : get_instance_ip instance_name=node1 (cluster.py:2082, get_instance_ip) 2025-04-03 23:44:32 [ 719 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestsettingsrandomization-gw7-node1-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-03 23:44:32 [ 719 ] DEBUG : get_instance_ip instance_name=node1 (cluster.py:2092, get_instance_global_ipv6) 2025-04-03 23:44:32 [ 719 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestsettingsrandomization-gw7-node1-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-03 23:44:32 [ 719 ] DEBUG : Waiting for ClickHouse start in node1, ip: 172.16.6.2... (cluster.py:3216, start) 2025-04-03 23:44:32 [ 719 ] DEBUG : http://localhost:None "GET /v1.46/containers/roottestsettingsrandomization-gw7-node1-1/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-03 23:44:32 [ 719 ] DEBUG : http://localhost:None "GET /v1.46/containers/282e35ed69a339ab53e7e1c3225c6fbc1fa361666fcf57765918dcc29afce4f6/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-03 23:44:32 [ 719 ] DEBUG : http://localhost:None "GET /v1.46/containers/282e35ed69a339ab53e7e1c3225c6fbc1fa361666fcf57765918dcc29afce4f6/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-03 23:44:32 [ 719 ] DEBUG : http://localhost:None "GET /v1.46/containers/282e35ed69a339ab53e7e1c3225c6fbc1fa361666fcf57765918dcc29afce4f6/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-03 23:44:33 [ 719 ] DEBUG : http://localhost:None "GET /v1.46/containers/282e35ed69a339ab53e7e1c3225c6fbc1fa361666fcf57765918dcc29afce4f6/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-03 23:44:33 [ 719 ] DEBUG : http://localhost:None "GET /v1.46/containers/282e35ed69a339ab53e7e1c3225c6fbc1fa361666fcf57765918dcc29afce4f6/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-03 23:44:33 [ 719 ] DEBUG : http://localhost:None "GET /v1.46/containers/282e35ed69a339ab53e7e1c3225c6fbc1fa361666fcf57765918dcc29afce4f6/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-03 23:44:33 [ 719 ] DEBUG : http://localhost:None "GET /v1.46/containers/282e35ed69a339ab53e7e1c3225c6fbc1fa361666fcf57765918dcc29afce4f6/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-03 23:44:33 [ 719 ] DEBUG : http://localhost:None "GET /v1.46/containers/282e35ed69a339ab53e7e1c3225c6fbc1fa361666fcf57765918dcc29afce4f6/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-03 23:44:33 [ 719 ] DEBUG : http://localhost:None "GET /v1.46/containers/282e35ed69a339ab53e7e1c3225c6fbc1fa361666fcf57765918dcc29afce4f6/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-03 23:44:33 [ 719 ] DEBUG : http://localhost:None "GET /v1.46/containers/282e35ed69a339ab53e7e1c3225c6fbc1fa361666fcf57765918dcc29afce4f6/json HTTP/1.1" 200 None (connectionpool.py:547, _make_request) 2025-04-03 23:44:33 [ 719 ] DEBUG : ClickHouse node1 started (cluster.py:3220, start) ------------------------------ Captured log call ------------------------------- 2025-04-03 23:44:33 [ 719 ] DEBUG : Executing query SELECT value FROM system.settings WHERE name = 'max_block_size' on node1 (cluster.py:3677, query) 2025-04-03 23:44:33 [ 719 ] DEBUG : Executing query SELECT changed FROM system.settings WHERE name = 'max_joined_block_size_rows' on node1 (cluster.py:3677, query) ---------------------------- Captured log teardown ----------------------------- 2025-04-03 23:44:34 [ 719 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_settings_randomization/_instances-0-gw7/.env --project-name roottestsettingsrandomization-gw7 --file /ClickHouse/tests/integration/test_settings_randomization/_instances-0-gw7/node1/docker-compose.yml stop --timeout 20] (cluster.py:122, run_and_check) 2025-04-03 23:44:36 [ 719 ] DEBUG : Stderr: Container roottestsettingsrandomization-gw7-node1-1 Stopping (cluster.py:148, run_and_check) 2025-04-03 23:44:36 [ 719 ] DEBUG : Stderr: Container roottestsettingsrandomization-gw7-node1-1 Stopped (cluster.py:148, run_and_check) 2025-04-03 23:44:36 [ 719 ] DEBUG : Command:[bash -c [ -f /ClickHouse/tests/integration/test_settings_randomization/_instances-0-gw7/node1/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_settings_randomization/_instances-0-gw7/node1/logs/stderr.log* | ( [ -z "" ] && cat || grep -v "$" ) || true] (cluster.py:122, run_and_check) 2025-04-03 23:44:36 [ 719 ] DEBUG : Command:[docker compose --env-file /ClickHouse/tests/integration/test_settings_randomization/_instances-0-gw7/.env --project-name roottestsettingsrandomization-gw7 --file /ClickHouse/tests/integration/test_settings_randomization/_instances-0-gw7/node1/docker-compose.yml down --volumes] (cluster.py:122, run_and_check) 2025-04-03 23:44:37 [ 719 ] DEBUG : Stderr: Container roottestsettingsrandomization-gw7-node1-1 Stopping (cluster.py:148, run_and_check) 2025-04-03 23:44:37 [ 719 ] DEBUG : Stderr: Container roottestsettingsrandomization-gw7-node1-1 Stopped (cluster.py:148, run_and_check) 2025-04-03 23:44:37 [ 719 ] DEBUG : Stderr: Container roottestsettingsrandomization-gw7-node1-1 Removing (cluster.py:148, run_and_check) 2025-04-03 23:44:37 [ 719 ] DEBUG : Stderr: Container roottestsettingsrandomization-gw7-node1-1 Removed (cluster.py:148, run_and_check) 2025-04-03 23:44:37 [ 719 ] DEBUG : Stderr: Network roottestsettingsrandomization-gw7_default Removing (cluster.py:148, run_and_check) 2025-04-03 23:44:37 [ 719 ] DEBUG : Stderr: Network roottestsettingsrandomization-gw7_default Removed (cluster.py:148, run_and_check) 2025-04-03 23:44:37 [ 719 ] DEBUG : Cleanup called (cluster.py:894, cleanup) 2025-04-03 23:44:37 [ 719 ] DEBUG : Docker networks for project roottestsettingsrandomization-gw7 are NETWORK ID NAME DRIVER SCOPE (cluster.py:873, print_all_docker_pieces) 2025-04-03 23:44:37 [ 719 ] DEBUG : Docker containers for project roottestsettingsrandomization-gw7 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:881, print_all_docker_pieces) 2025-04-03 23:44:37 [ 719 ] DEBUG : Docker volumes for project roottestsettingsrandomization-gw7 are DRIVER VOLUME NAME (cluster.py:889, print_all_docker_pieces) 2025-04-03 23:44:37 [ 719 ] DEBUG : Command:[docker container list --all --filter name='^/roottestsettingsrandomization-gw7-.*-1$' --format '{{.ID}}:{{.Names}}'] (cluster.py:122, run_and_check) 2025-04-03 23:44:37 [ 719 ] DEBUG : Unstopped containers: {} (cluster.py:908, cleanup) 2025-04-03 23:44:37 [ 719 ] DEBUG : No running containers for project: roottestsettingsrandomization-gw7 (cluster.py:922, cleanup) 2025-04-03 23:44:37 [ 719 ] DEBUG : Trying to prune unused networks... (cluster.py:928, cleanup) 2025-04-03 23:44:37 [ 719 ] DEBUG : Trying to prune unused images... (cluster.py:944, cleanup) 2025-04-03 23:44:37 [ 719 ] DEBUG : Command:[docker image prune -f] (cluster.py:122, run_and_check) 2025-04-03 23:44:37 [ 719 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:146, run_and_check) 2025-04-03 23:44:37 [ 719 ] DEBUG : Images pruned (cluster.py:947, cleanup) 2025-04-03 23:44:37 [ 719 ] DEBUG : Trying to prune unused volumes... (cluster.py:953, cleanup) 2025-04-03 23:44:37 [ 719 ] DEBUG : Command:[docker volume ls | wc -l] (cluster.py:122, run_and_check) 2025-04-03 23:44:37 [ 719 ] DEBUG : Stdout:15 (cluster.py:146, run_and_check) 2025-04-03 23:44:37 [ 719 ] DEBUG : Command:[docker volume prune -f] (cluster.py:122, run_and_check) 2025-04-03 23:44:37 [ 719 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:146, run_and_check) 2025-04-03 23:44:37 [ 719 ] DEBUG : Volumes pruned: 15 (cluster.py:958, cleanup) =============================== warnings summary =============================== test_storage_mongodb_legacy/test.py::test_arrays[False] /ClickHouse/tests/integration/test_storage_mongodb_legacy/test.py:136: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_storage_mongodb_legacy/test.py::test_arrays[False] test_storage_mongodb_legacy/test.py::test_secure_connection[True] test_storage_mongodb_legacy/test.py::test_simple_insert_select[False] /usr/local/lib/python3.10/dist-packages/pymongo/database.py:1247: DeprecationWarning: Creating a user with the read_only option or without roles is deprecated in MongoDB >= 2.6 warnings.warn("Creating a user with the read_only option " test_storage_mongodb_legacy/test.py::test_auth_source[False] /ClickHouse/tests/integration/test_storage_mongodb_legacy/test.py:425: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead admin_db.add_user( test_storage_mongodb_legacy/test.py::test_complex_data_type[False] /ClickHouse/tests/integration/test_storage_mongodb_legacy/test.py:295: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_storage_mongodb_legacy/test.py::test_incorrect_data_type[False] /ClickHouse/tests/integration/test_storage_mongodb_legacy/test.py:325: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_storage_mongodb_legacy/test.py::test_missing_columns[False] /ClickHouse/tests/integration/test_storage_mongodb_legacy/test.py:462: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_storage_mongodb_legacy/test.py::test_predefined_connection_configuration[False] /ClickHouse/tests/integration/test_storage_mongodb_legacy/test.py:386: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_storage_mongodb_legacy/test.py::test_secure_connection[True] /ClickHouse/tests/integration/test_storage_mongodb_legacy/test.py:356: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_storage_mongodb_legacy/test.py::test_simple_insert_select[False] /ClickHouse/tests/integration/test_storage_mongodb_legacy/test.py:486: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_storage_mongodb_legacy/test.py::test_simple_select[False] /ClickHouse/tests/integration/test_storage_mongodb_legacy/test.py:72: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_storage_mongodb_legacy/test.py::test_simple_select_from_view[False] /ClickHouse/tests/integration/test_storage_mongodb_legacy/test.py:102: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_storage_mongodb_legacy/test.py::test_uuid[False] /ClickHouse/tests/integration/test_storage_mongodb_legacy/test.py:50: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_storage_mongodb_legacy/test.py::test_uuid[False] /ClickHouse/tests/integration/test_storage_mongodb_legacy/test.py:52: DeprecationWarning: insert is deprecated. Use insert_one or insert_many instead. mongo_table.insert({"key": 0, "data": UUID("f0e77736-91d1-48ce-8f01-15123ca1c7ed")}) test_storage_azure_blob_storage/test.py: 1460 warnings /usr/local/lib/python3.10/dist-packages/azure/storage/blob/_container_client.py:1781: DeprecationWarning: The use of a 'BlobProperties' instance for param blob is deprecated. Please use 'BlobProperties.name' or any other str input type instead. warnings.warn( -- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html ============================== slowest durations =============================== 169.04s setup test_storage_azure_blob_storage/test.py::test_azure_glob_scheherazade 59.94s call test_storage_azure_blob_storage/test.py::test_azure_glob_scheherazade 35.17s setup test_storage_mysql/test.py::test_binary_type 31.19s teardown test_storage_azure_blob_storage/test.py::test_write_to_globbed_partitioned_path 30.25s setup test_server_initialization/test.py::test_partially_dropped_tables 28.85s setup test_storage_mongodb_legacy/test.py::test_arrays[False] 26.49s setup test_storage_mongodb_legacy/test.py::test_secure_connection[True] 26.44s setup test_storage_mongodb_legacy/test.py::test_simple_insert_select[False] 18.57s call test_storage_azure_blob_storage/test.py::test_put_get_with_globs 17.85s call test_storage_azure_blob_storage/test.py::test_schema_inference_from_globs 17.10s setup test_storage_postgresql/test.py::test_auto_close_connection 16.93s call test_storage_azure_blob_storage/test.py::test_schema_inference_cache 16.30s call test_startup_scripts/test.py::test_startup_scripts 16.04s setup test_sharding_key_from_default_column/test.py::test_default_column 13.26s setup test_select_access_rights/test_main.py::test_select_with_row_policy 13.01s setup test_settings_constraints/test.py::test_max_constraint 12.84s setup test_server_start_and_ip_conversions/test.py::test_restart_success_ipv4 12.56s setup test_stop_insert_when_disk_close_to_full/test.py::test_insert_stops_when_disk_full 12.03s call test_storage_postgresql/test.py::test_concurrent_queries 10.27s call test_storage_policies/test.py::test_storage_policy_configuration_change 10.23s call test_storage_mysql/test.py::test_settings_connection_wait_timeout 9.17s setup test_startup_scripts_execution_state/test.py::test_startup_execution_state 7.67s teardown test_sharding_key_from_default_column/test.py::test_materialized_column_disallow_insert_materialized_different_shards 7.26s setup test_storage_policies/test.py::test_storage_policy_configuration_change 7.14s teardown test_storage_mysql/test.py::test_where 6.95s call test_storage_azure_blob_storage/test.py::test_put_get_with_globs_tf 6.79s call test_storage_azure_blob_storage/test.py::test_schema_inference_from_globs_tf 5.61s call test_stop_insert_when_disk_close_to_full/test.py::test_insert_stops_when_disk_full 4.90s call test_storage_postgresql/test.py::test_filter_pushdown 4.53s teardown test_stop_insert_when_disk_close_to_full/test.py::test_min_free_disk_settings 4.44s setup test_settings_from_server/test.py::test_settings_from_server 4.37s call test_server_start_and_ip_conversions/test.py::test_restart_success_ipv4 4.23s call test_server_start_and_ip_conversions/test.py::test_restart_success_ipv6 4.21s setup test_storage_azure_blob_storage/test.py::test_create_new_files_on_insert 3.97s teardown test_select_access_rights/test_main.py::test_select_with_row_policy 3.85s teardown test_storage_postgresql/test.py::test_filter_pushdown 3.52s setup test_settings_randomization/test.py::test_settings_randomization 3.47s teardown test_settings_randomization/test.py::test_settings_randomization 3.42s teardown test_settings_from_server/test.py::test_settings_from_server 2.99s teardown test_storage_mongodb_legacy/test.py::test_uuid[False] 2.98s teardown test_settings_constraints/test.py::test_system_settings 2.96s call test_sharding_key_from_default_column/test.py::test_default_column 2.45s call test_sharding_key_from_default_column/test.py::test_materialized_column_allow_insert_materialized 2.30s call test_storage_mongodb_legacy/test.py::test_arrays[False] 2.24s call test_sharding_key_from_default_column/test.py::test_materialized_column_disallow_insert_materialized 2.06s call test_storage_azure_blob_storage/test.py::test_format_detection 2.02s teardown test_startup_scripts_execution_state/test.py::test_startup_execution_state 1.89s call test_sharding_key_from_default_column/test.py::test_materialized_column_disallow_insert_materialized_different_shards 1.72s teardown test_server_start_and_ip_conversions/test.py::test_restart_success_ipv6 1.45s call test_storage_mongodb_legacy/test.py::test_secure_connection[True] 1.20s call test_storage_azure_blob_storage/test.py::test_parallel_read 1.16s call test_stop_insert_when_disk_close_to_full/test.py::test_min_free_disk_settings 1.14s teardown test_storage_policies/test.py::test_storage_policy_configuration_change 1.12s call test_storage_mysql/test.py::test_table_function 1.08s teardown test_server_initialization/test.py::test_sophisticated_default 1.05s call test_storage_mysql/test.py::test_settings 1.02s call test_storage_mysql/test.py::test_external_settings 0.96s call test_storage_mysql/test.py::test_insert_on_duplicate_select 0.95s call test_settings_from_server/test.py::test_settings_from_server 0.92s call test_storage_mysql/test.py::test_where 0.91s call test_storage_mysql/test.py::test_predefined_connection_configuration 0.89s call test_storage_mysql/test.py::test_insert_select 0.79s call test_storage_mysql/test.py::test_replace_select 0.73s call test_settings_constraints/test.py::test_read_only_constraint 0.73s call test_storage_mongodb_legacy/test.py::test_simple_insert_select[False] 0.73s call test_storage_azure_blob_storage/test.py::test_union_schema_inference_mode 0.71s call test_settings_constraints/test.py::test_min_constraint 0.71s call test_storage_azure_blob_storage/test.py::test_function_signatures 0.65s call test_storage_postgresql/test.py::test_auto_close_connection 0.64s call test_select_access_rights/test_main.py::test_select_with_row_policy 0.63s call test_storage_mysql/test.py::test_mysql_in 0.59s teardown test_sharding_key_from_default_column/test.py::test_materialized_column_allow_insert_materialized 0.59s call test_storage_mysql/test.py::test_mysql_point 0.59s call test_storage_mysql/test.py::test_many_connections 0.57s call test_settings_constraints/test.py::test_max_constraint 0.55s call test_storage_mongodb_legacy/test.py::test_auth_source[False] 0.54s call test_storage_mysql/test.py::test_joins 0.50s call test_storage_azure_blob_storage/test.py::test_create_new_files_on_insert 0.50s call test_storage_azure_blob_storage/test.py::test_overwrite 0.49s call test_storage_azure_blob_storage/test.py::test_read_subcolumns 0.49s call test_storage_mongodb_legacy/test.py::test_incorrect_data_type[False] 0.49s call test_settings_constraints/test.py::test_system_constraints 0.45s call test_storage_azure_blob_storage/test.py::test_schema_inference_no_globs 0.45s call test_storage_azure_blob_storage/test.py::test_respect_object_existence_on_partitioned_write 0.44s call test_storage_azure_blob_storage/test.py::test_filtering_by_file_or_path 0.43s call test_storage_postgresql/test.py::test_datetime_with_timezone 0.43s call test_storage_mongodb_legacy/test.py::test_simple_select_from_view[False] 0.42s call test_storage_mongodb_legacy/test.py::test_complex_data_type[False] 0.42s setup test_storage_azure_blob_storage/test.py::test_read_from_not_existing_container 0.41s call test_storage_mongodb_legacy/test.py::test_no_credentials[False] 0.39s call test_storage_mysql/test.py::test_enum_type 0.39s call test_storage_mongodb_legacy/test.py::test_simple_select[False] 0.38s setup test_storage_azure_blob_storage/test.py::test_schema_inference_from_globs_tf 0.36s call test_storage_mongodb_legacy/test.py::test_uuid[False] 0.35s call test_server_initialization/test.py::test_partially_dropped_tables 0.35s call test_storage_mysql/test.py::test_schema_inference 0.35s call test_storage_mysql/test.py::test_mysql_null 0.35s teardown test_sharding_key_from_default_column/test.py::test_materialized_column_disallow_insert_materialized 0.34s setup test_storage_azure_blob_storage/test.py::test_put_get_with_globs_tf 0.33s teardown test_sharding_key_from_default_column/test.py::test_default_column 0.33s call test_storage_azure_blob_storage/test.py::test_simple_read_write 0.32s call test_storage_mongodb_legacy/test.py::test_missing_columns[False] 0.32s setup test_storage_azure_blob_storage/test.py::test_schema_inference_no_globs 0.31s call test_settings_constraints/test.py::test_system_settings 0.29s call test_storage_mongodb_legacy/test.py::test_predefined_connection_configuration[False] 0.29s call test_storage_azure_blob_storage/test.py::test_insert_create_new_file 0.28s call test_storage_azure_blob_storage/test.py::test_truncate 0.26s call test_storage_azure_blob_storage/test.py::test_size_virtual_column 0.24s call test_storage_azure_blob_storage/test.py::test_storage_azure_get_gzip[bin] 0.24s call test_storage_azure_blob_storage/test.py::test_storage_azure_get_gzip[gz] 0.23s call test_storage_azure_blob_storage/test.py::test_read_subcolumn_time 0.21s call test_storage_azure_blob_storage/test.py::test_insert_with_path_with_globs 0.21s call test_storage_azure_blob_storage/test.py::test_partition_by_string_column 0.21s call test_storage_azure_blob_storage/test.py::test_simple_write_account_string 0.21s call test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_2 0.21s call test_storage_azure_blob_storage/test.py::test_simple_write_connection_string 0.20s call test_storage_mysql/test.py::test_binary_type 0.20s call test_startup_scripts_execution_state/test.py::test_startup_execution_state 0.19s call test_storage_azure_blob_storage/test.py::test_hive_partitioning_with_one_parameter 0.19s call test_settings_randomization/test.py::test_settings_randomization 0.18s call test_storage_azure_blob_storage/test.py::test_hive_partitioning_without_setting 0.18s call test_storage_azure_blob_storage/test.py::test_partition_by 0.17s call test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_1 0.17s call test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_1_table_function 0.17s call test_storage_azure_blob_storage/test.py::test_partition_by_const_column 0.13s teardown test_storage_postgresql/test.py::test_concurrent_queries 0.13s call test_server_initialization/test.py::test_sophisticated_default 0.13s teardown test_storage_postgresql/test.py::test_datetime64 0.13s call test_storage_azure_blob_storage/test.py::test_hive_partitioning_with_all_parameters 0.13s call test_storage_azure_blob_storage/test.py::test_schema_inference_no_globs_tf 0.13s call test_storage_azure_blob_storage/test.py::test_filter_using_file 0.10s teardown test_storage_postgresql/test.py::test_auto_close_connection 0.10s call test_storage_azure_blob_storage/test.py::test_create_table_account_string 0.10s call test_storage_azure_blob_storage/test.py::test_create_table_connection_string 0.08s call test_storage_azure_blob_storage/test.py::test_partition_by_tf 0.08s call test_storage_azure_blob_storage/test.py::test_simple_write_account_string_table_function 0.08s call test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_2_table_function 0.08s call test_storage_azure_blob_storage/test.py::test_simple_write_connection_string_table_function 0.07s call test_storage_postgresql/test.py::test_datetime64 0.07s teardown test_storage_postgresql/test.py::test_datetime_with_timezone 0.07s call test_storage_azure_blob_storage/test.py::test_read_from_not_existing_container 0.07s call test_storage_azure_blob_storage/test.py::test_write_to_globbed_partitioned_path 0.05s setup test_storage_azure_blob_storage/test.py::test_hive_partitioning_without_setting 0.05s setup test_storage_azure_blob_storage/test.py::test_schema_inference_from_globs 0.03s setup test_storage_azure_blob_storage/test.py::test_storage_azure_get_gzip[bin] 0.03s setup test_storage_azure_blob_storage/test.py::test_write_to_globbed_partitioned_path 0.03s setup test_storage_azure_blob_storage/test.py::test_filtering_by_file_or_path 0.03s setup test_storage_azure_blob_storage/test.py::test_read_subcolumns 0.03s setup test_storage_azure_blob_storage/test.py::test_partition_by_tf 0.03s setup test_storage_azure_blob_storage/test.py::test_format_detection 0.03s setup test_storage_azure_blob_storage/test.py::test_partition_by_const_column 0.03s setup test_storage_azure_blob_storage/test.py::test_hive_partitioning_with_one_parameter 0.03s setup test_storage_azure_blob_storage/test.py::test_create_table_account_string 0.03s setup test_storage_azure_blob_storage/test.py::test_hive_partitioning_with_all_parameters 0.03s setup test_storage_azure_blob_storage/test.py::test_insert_with_path_with_globs 0.03s setup test_storage_azure_blob_storage/test.py::test_put_get_with_globs 0.03s setup test_storage_azure_blob_storage/test.py::test_truncate 0.03s setup test_storage_azure_blob_storage/test.py::test_schema_inference_cache 0.03s setup test_storage_azure_blob_storage/test.py::test_respect_object_existence_on_partitioned_write 0.02s setup test_storage_azure_blob_storage/test.py::test_simple_write_account_string 0.02s setup test_storage_azure_blob_storage/test.py::test_insert_create_new_file 0.02s setup test_storage_azure_blob_storage/test.py::test_function_signatures 0.02s setup test_storage_azure_blob_storage/test.py::test_storage_azure_get_gzip[gz] 0.02s setup test_storage_azure_blob_storage/test.py::test_read_subcolumn_time 0.02s setup test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_2 0.02s setup test_storage_azure_blob_storage/test.py::test_simple_write_connection_string 0.02s setup test_storage_azure_blob_storage/test.py::test_partition_by_string_column 0.02s setup test_storage_azure_blob_storage/test.py::test_simple_write_connection_string_table_function 0.02s setup test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_2_table_function 0.02s setup test_storage_azure_blob_storage/test.py::test_simple_write_account_string_table_function 0.02s setup test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_1_table_function 0.02s setup test_storage_azure_blob_storage/test.py::test_partition_by 0.02s setup test_storage_azure_blob_storage/test.py::test_parallel_read 0.02s setup test_storage_azure_blob_storage/test.py::test_simple_read_write 0.02s setup test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_1 0.02s setup test_storage_azure_blob_storage/test.py::test_schema_inference_no_globs_tf 0.02s setup test_storage_azure_blob_storage/test.py::test_size_virtual_column 0.02s setup test_storage_azure_blob_storage/test.py::test_union_schema_inference_mode 0.02s setup test_storage_azure_blob_storage/test.py::test_filter_using_file 0.02s setup test_storage_azure_blob_storage/test.py::test_overwrite 0.02s setup test_storage_azure_blob_storage/test.py::test_create_table_connection_string 0.00s teardown test_storage_azure_blob_storage/test.py::test_create_new_files_on_insert 0.00s teardown test_storage_azure_blob_storage/test.py::test_azure_glob_scheherazade 0.00s setup test_sharding_key_from_default_column/test.py::test_materialized_column_allow_insert_materialized 0.00s teardown test_storage_azure_blob_storage/test.py::test_read_from_not_existing_container 0.00s teardown test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_2 0.00s setup test_settings_constraints/test.py::test_read_only_constraint 0.00s setup test_storage_postgresql/test.py::test_datetime64 0.00s teardown test_storage_azure_blob_storage/test.py::test_schema_inference_no_globs 0.00s setup test_server_start_and_ip_conversions/test.py::test_restart_success_ipv6 0.00s teardown test_storage_mysql/test.py::test_binary_type 0.00s teardown test_storage_azure_blob_storage/test.py::test_read_subcolumn_time 0.00s setup test_storage_postgresql/test.py::test_concurrent_queries 0.00s setup test_storage_postgresql/test.py::test_filter_pushdown 0.00s teardown test_storage_azure_blob_storage/test.py::test_partition_by_string_column 0.00s setup test_settings_constraints/test.py::test_min_constraint 0.00s setup test_sharding_key_from_default_column/test.py::test_materialized_column_disallow_insert_materialized_different_shards 0.00s setup test_storage_mysql/test.py::test_enum_type 0.00s teardown test_storage_azure_blob_storage/test.py::test_schema_inference_from_globs 0.00s setup test_storage_mongodb_legacy/test.py::test_predefined_connection_configuration[False] 0.00s teardown test_storage_azure_blob_storage/test.py::test_schema_inference_from_globs_tf 0.00s setup test_storage_mongodb_legacy/test.py::test_missing_columns[False] 0.00s teardown test_storage_azure_blob_storage/test.py::test_put_get_with_globs_tf 0.00s setup test_storage_postgresql/test.py::test_datetime_with_timezone 0.00s teardown test_storage_azure_blob_storage/test.py::test_simple_write_account_string 0.00s teardown test_storage_azure_blob_storage/test.py::test_simple_write_connection_string 0.00s teardown test_storage_azure_blob_storage/test.py::test_schema_inference_cache 0.00s setup test_startup_scripts/test.py::test_startup_scripts 0.00s teardown test_startup_scripts/test.py::test_startup_scripts 0.00s setup test_server_initialization/test.py::test_sophisticated_default 0.00s teardown test_server_initialization/test.py::test_partially_dropped_tables 0.00s teardown test_storage_azure_blob_storage/test.py::test_storage_azure_get_gzip[bin] 0.00s teardown test_storage_azure_blob_storage/test.py::test_hive_partitioning_with_one_parameter 0.00s teardown test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_1_table_function 0.00s setup test_settings_constraints/test.py::test_system_settings 0.00s teardown test_storage_azure_blob_storage/test.py::test_storage_azure_get_gzip[gz] 0.00s teardown test_storage_azure_blob_storage/test.py::test_simple_write_connection_string_table_function 0.00s setup test_storage_mysql/test.py::test_mysql_in 0.00s teardown test_storage_azure_blob_storage/test.py::test_put_get_with_globs 0.00s teardown test_storage_mongodb_legacy/test.py::test_no_credentials[False] 0.00s teardown test_storage_azure_blob_storage/test.py::test_insert_with_path_with_globs 0.00s teardown test_storage_mongodb_legacy/test.py::test_simple_insert_select[False] 0.00s teardown test_stop_insert_when_disk_close_to_full/test.py::test_insert_stops_when_disk_full 0.00s setup test_sharding_key_from_default_column/test.py::test_materialized_column_disallow_insert_materialized 0.00s teardown test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_1 0.00s teardown test_settings_constraints/test.py::test_max_constraint 0.00s teardown test_storage_azure_blob_storage/test.py::test_simple_write_account_string_table_function 0.00s teardown test_storage_azure_blob_storage/test.py::test_partition_by_tf 0.00s teardown test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_2_table_function 0.00s teardown test_storage_mongodb_legacy/test.py::test_incorrect_data_type[False] 0.00s teardown test_storage_azure_blob_storage/test.py::test_simple_read_write 0.00s teardown test_storage_azure_blob_storage/test.py::test_union_schema_inference_mode 0.00s teardown test_settings_constraints/test.py::test_min_constraint 0.00s teardown test_storage_azure_blob_storage/test.py::test_truncate 0.00s setup test_storage_mysql/test.py::test_table_function 0.00s teardown test_storage_azure_blob_storage/test.py::test_function_signatures 0.00s setup test_storage_mysql/test.py::test_replace_select 0.00s setup test_storage_mongodb_legacy/test.py::test_complex_data_type[False] 0.00s setup test_storage_mysql/test.py::test_mysql_null 0.00s teardown test_storage_azure_blob_storage/test.py::test_size_virtual_column 0.00s teardown test_storage_mongodb_legacy/test.py::test_arrays[False] 0.00s setup test_storage_mongodb_legacy/test.py::test_simple_select[False] 0.00s setup test_storage_mysql/test.py::test_where 0.00s setup test_storage_mysql/test.py::test_insert_on_duplicate_select 0.00s setup test_stop_insert_when_disk_close_to_full/test.py::test_min_free_disk_settings 0.00s teardown test_storage_mysql/test.py::test_external_settings 0.00s teardown test_storage_azure_blob_storage/test.py::test_partition_by_const_column 0.00s setup test_storage_mysql/test.py::test_schema_inference 0.00s teardown test_storage_azure_blob_storage/test.py::test_respect_object_existence_on_partitioned_write 0.00s teardown test_storage_azure_blob_storage/test.py::test_filter_using_file 0.00s teardown test_storage_mongodb_legacy/test.py::test_secure_connection[True] 0.00s teardown test_storage_mongodb_legacy/test.py::test_predefined_connection_configuration[False] 0.00s setup test_storage_mysql/test.py::test_joins 0.00s teardown test_storage_azure_blob_storage/test.py::test_parallel_read 0.00s teardown test_storage_azure_blob_storage/test.py::test_format_detection 0.00s setup test_storage_mongodb_legacy/test.py::test_no_credentials[False] 0.00s teardown test_storage_azure_blob_storage/test.py::test_hive_partitioning_with_all_parameters 0.00s teardown test_storage_azure_blob_storage/test.py::test_filtering_by_file_or_path 0.00s setup test_storage_mongodb_legacy/test.py::test_auth_source[False] 0.00s setup test_storage_mongodb_legacy/test.py::test_uuid[False] 0.00s setup test_storage_mysql/test.py::test_settings_connection_wait_timeout 0.00s teardown test_server_start_and_ip_conversions/test.py::test_restart_success_ipv4 0.00s setup test_storage_mongodb_legacy/test.py::test_simple_select_from_view[False] 0.00s setup test_storage_mysql/test.py::test_many_connections 0.00s setup test_storage_mysql/test.py::test_insert_select 0.00s teardown test_storage_azure_blob_storage/test.py::test_partition_by 0.00s teardown test_storage_azure_blob_storage/test.py::test_create_table_account_string 0.00s teardown test_storage_azure_blob_storage/test.py::test_overwrite 0.00s teardown test_storage_azure_blob_storage/test.py::test_insert_create_new_file 0.00s setup test_storage_mysql/test.py::test_predefined_connection_configuration 0.00s setup test_storage_mysql/test.py::test_mysql_point 0.00s teardown test_settings_constraints/test.py::test_system_constraints 0.00s teardown test_storage_mongodb_legacy/test.py::test_auth_source[False] 0.00s setup test_storage_mysql/test.py::test_settings 0.00s setup test_storage_mysql/test.py::test_external_settings 0.00s setup test_settings_constraints/test.py::test_system_constraints 0.00s teardown test_storage_azure_blob_storage/test.py::test_read_subcolumns 0.00s teardown test_storage_azure_blob_storage/test.py::test_hive_partitioning_without_setting 0.00s teardown test_settings_constraints/test.py::test_read_only_constraint 0.00s teardown test_storage_mysql/test.py::test_mysql_in 0.00s setup test_storage_mongodb_legacy/test.py::test_incorrect_data_type[False] 0.00s teardown test_storage_mysql/test.py::test_replace_select 0.00s teardown test_storage_mysql/test.py::test_settings 0.00s teardown test_storage_mysql/test.py::test_joins 0.00s teardown test_storage_azure_blob_storage/test.py::test_create_table_connection_string 0.00s teardown test_storage_azure_blob_storage/test.py::test_schema_inference_no_globs_tf 0.00s teardown test_storage_mongodb_legacy/test.py::test_missing_columns[False] 0.00s teardown test_storage_mysql/test.py::test_insert_select 0.00s teardown test_storage_mysql/test.py::test_schema_inference 0.00s teardown test_storage_mysql/test.py::test_table_function 0.00s teardown test_storage_mongodb_legacy/test.py::test_simple_select[False] 0.00s teardown test_storage_mysql/test.py::test_mysql_null 0.00s teardown test_storage_mysql/test.py::test_settings_connection_wait_timeout 0.00s teardown test_storage_mongodb_legacy/test.py::test_simple_select_from_view[False] 0.00s teardown test_storage_mysql/test.py::test_many_connections 0.00s teardown test_storage_mysql/test.py::test_predefined_connection_configuration 0.00s teardown test_storage_mysql/test.py::test_enum_type 0.00s teardown test_storage_mysql/test.py::test_mysql_point 0.00s teardown test_storage_mysql/test.py::test_insert_on_duplicate_select 0.00s teardown test_storage_mongodb_legacy/test.py::test_complex_data_type[False] =========================== short test summary info ============================ FAILED test_settings_randomization/test.py::test_settings_randomization - Ass... PASSED test_settings_constraints/test.py::test_max_constraint PASSED test_select_access_rights/test_main.py::test_select_with_row_policy PASSED test_settings_constraints/test.py::test_min_constraint PASSED test_settings_constraints/test.py::test_read_only_constraint PASSED test_settings_constraints/test.py::test_system_constraints PASSED test_settings_constraints/test.py::test_system_settings PASSED test_server_start_and_ip_conversions/test.py::test_restart_success_ipv4 PASSED test_storage_postgresql/test.py::test_auto_close_connection PASSED test_stop_insert_when_disk_close_to_full/test.py::test_insert_stops_when_disk_full PASSED test_sharding_key_from_default_column/test.py::test_default_column PASSED test_stop_insert_when_disk_close_to_full/test.py::test_min_free_disk_settings PASSED test_server_start_and_ip_conversions/test.py::test_restart_success_ipv6 PASSED test_sharding_key_from_default_column/test.py::test_materialized_column_allow_insert_materialized PASSED test_sharding_key_from_default_column/test.py::test_materialized_column_disallow_insert_materialized PASSED test_sharding_key_from_default_column/test.py::test_materialized_column_disallow_insert_materialized_different_shards PASSED test_startup_scripts_execution_state/test.py::test_startup_execution_state PASSED test_storage_postgresql/test.py::test_concurrent_queries PASSED test_storage_postgresql/test.py::test_datetime64 PASSED test_server_initialization/test.py::test_partially_dropped_tables PASSED test_storage_postgresql/test.py::test_datetime_with_timezone PASSED test_server_initialization/test.py::test_sophisticated_default PASSED test_storage_mongodb_legacy/test.py::test_arrays[False] PASSED test_storage_mongodb_legacy/test.py::test_auth_source[False] PASSED test_storage_mongodb_legacy/test.py::test_complex_data_type[False] PASSED test_storage_mongodb_legacy/test.py::test_incorrect_data_type[False] PASSED test_storage_mongodb_legacy/test.py::test_missing_columns[False] PASSED test_storage_mongodb_legacy/test.py::test_no_credentials[False] PASSED test_storage_mongodb_legacy/test.py::test_predefined_connection_configuration[False] PASSED test_storage_mysql/test.py::test_binary_type PASSED test_storage_postgresql/test.py::test_filter_pushdown PASSED test_storage_mysql/test.py::test_enum_type PASSED test_storage_policies/test.py::test_storage_policy_configuration_change PASSED test_storage_mysql/test.py::test_external_settings PASSED test_settings_from_server/test.py::test_settings_from_server PASSED test_storage_mysql/test.py::test_insert_on_duplicate_select PASSED test_storage_mysql/test.py::test_insert_select PASSED test_storage_mysql/test.py::test_joins PASSED test_storage_mysql/test.py::test_many_connections PASSED test_startup_scripts/test.py::test_startup_scripts PASSED test_storage_mysql/test.py::test_mysql_in PASSED test_storage_mysql/test.py::test_mysql_null PASSED test_storage_mysql/test.py::test_mysql_point PASSED test_storage_mysql/test.py::test_predefined_connection_configuration PASSED test_storage_mysql/test.py::test_replace_select PASSED test_storage_mysql/test.py::test_schema_inference PASSED test_storage_mysql/test.py::test_settings PASSED test_storage_mysql/test.py::test_settings_connection_wait_timeout PASSED test_storage_mysql/test.py::test_table_function PASSED test_storage_mysql/test.py::test_where PASSED test_storage_mongodb_legacy/test.py::test_secure_connection[True] PASSED test_storage_mongodb_legacy/test.py::test_simple_insert_select[False] PASSED test_storage_mongodb_legacy/test.py::test_simple_select[False] PASSED test_storage_mongodb_legacy/test.py::test_simple_select_from_view[False] PASSED test_storage_mongodb_legacy/test.py::test_uuid[False] PASSED test_storage_azure_blob_storage/test.py::test_azure_glob_scheherazade PASSED test_storage_azure_blob_storage/test.py::test_create_new_files_on_insert PASSED test_storage_azure_blob_storage/test.py::test_create_table_account_string PASSED test_storage_azure_blob_storage/test.py::test_create_table_connection_string PASSED test_storage_azure_blob_storage/test.py::test_filter_using_file PASSED test_storage_azure_blob_storage/test.py::test_filtering_by_file_or_path PASSED test_storage_azure_blob_storage/test.py::test_format_detection PASSED test_storage_azure_blob_storage/test.py::test_function_signatures PASSED test_storage_azure_blob_storage/test.py::test_hive_partitioning_with_all_parameters PASSED test_storage_azure_blob_storage/test.py::test_hive_partitioning_with_one_parameter PASSED test_storage_azure_blob_storage/test.py::test_hive_partitioning_without_setting PASSED test_storage_azure_blob_storage/test.py::test_insert_create_new_file PASSED test_storage_azure_blob_storage/test.py::test_insert_with_path_with_globs PASSED test_storage_azure_blob_storage/test.py::test_overwrite PASSED test_storage_azure_blob_storage/test.py::test_parallel_read PASSED test_storage_azure_blob_storage/test.py::test_partition_by PASSED test_storage_azure_blob_storage/test.py::test_partition_by_const_column PASSED test_storage_azure_blob_storage/test.py::test_partition_by_string_column PASSED test_storage_azure_blob_storage/test.py::test_partition_by_tf PASSED test_storage_azure_blob_storage/test.py::test_put_get_with_globs PASSED test_storage_azure_blob_storage/test.py::test_put_get_with_globs_tf PASSED test_storage_azure_blob_storage/test.py::test_read_from_not_existing_container PASSED test_storage_azure_blob_storage/test.py::test_read_subcolumn_time PASSED test_storage_azure_blob_storage/test.py::test_read_subcolumns PASSED test_storage_azure_blob_storage/test.py::test_respect_object_existence_on_partitioned_write PASSED test_storage_azure_blob_storage/test.py::test_schema_inference_cache PASSED test_storage_azure_blob_storage/test.py::test_schema_inference_from_globs PASSED test_storage_azure_blob_storage/test.py::test_schema_inference_from_globs_tf PASSED test_storage_azure_blob_storage/test.py::test_schema_inference_no_globs PASSED test_storage_azure_blob_storage/test.py::test_schema_inference_no_globs_tf PASSED test_storage_azure_blob_storage/test.py::test_simple_read_write PASSED test_storage_azure_blob_storage/test.py::test_simple_write_account_string PASSED test_storage_azure_blob_storage/test.py::test_simple_write_account_string_table_function PASSED test_storage_azure_blob_storage/test.py::test_simple_write_connection_string PASSED test_storage_azure_blob_storage/test.py::test_simple_write_connection_string_table_function PASSED test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_1 PASSED test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_1_table_function PASSED test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_2 PASSED test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_2_table_function PASSED test_storage_azure_blob_storage/test.py::test_size_virtual_column PASSED test_storage_azure_blob_storage/test.py::test_storage_azure_get_gzip[bin] PASSED test_storage_azure_blob_storage/test.py::test_storage_azure_get_gzip[gz] PASSED test_storage_azure_blob_storage/test.py::test_truncate PASSED test_storage_azure_blob_storage/test.py::test_union_schema_inference_mode PASSED test_storage_azure_blob_storage/test.py::test_write_to_globbed_partitioned_path =========== 1 failed, 99 passed, 1475 warnings in 348.84s (0:05:48) ============ Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration/./runner", line 528, in subprocess.check_call(cmd, shell=True) File "/usr/lib/python3.10/subprocess.py", line 369, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command 'docker run --rm --name clickhouse_integration_tests_qiz37x --privileged --dns-search='.' --memory=30709039104 --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=5dc43a6382f0 -e DOCKER_BASE_TAG=6712d5cc610d -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=caad4729259e -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_select_access_rights/test_main.py::test_select_with_row_policy test_server_initialization/test.py::test_partially_dropped_tables test_server_initialization/test.py::test_sophisticated_default test_server_start_and_ip_conversions/test.py::test_restart_success_ipv4 test_server_start_and_ip_conversions/test.py::test_restart_success_ipv6 test_settings_constraints/test.py::test_max_constraint test_settings_constraints/test.py::test_min_constraint test_settings_constraints/test.py::test_read_only_constraint test_settings_constraints/test.py::test_system_constraints test_settings_constraints/test.py::test_system_settings test_settings_from_server/test.py::test_settings_from_server test_settings_randomization/test.py::test_settings_randomization test_sharding_key_from_default_column/test.py::test_default_column test_sharding_key_from_default_column/test.py::test_materialized_column_allow_insert_materialized test_sharding_key_from_default_column/test.py::test_materialized_column_disallow_insert_materialized test_sharding_key_from_default_column/test.py::test_materialized_column_disallow_insert_materialized_different_shards test_startup_scripts/test.py::test_startup_scripts test_startup_scripts_execution_state/test.py::test_startup_execution_state test_stop_insert_when_disk_close_to_full/test.py::test_insert_stops_when_disk_full test_stop_insert_when_disk_close_to_full/test.py::test_min_free_disk_settings test_storage_azure_blob_storage/test.py::test_azure_glob_scheherazade test_storage_azure_blob_storage/test.py::test_create_new_files_on_insert test_storage_azure_blob_storage/test.py::test_create_table_account_string test_storage_azure_blob_storage/test.py::test_create_table_connection_string test_storage_azure_blob_storage/test.py::test_filter_using_file test_storage_azure_blob_storage/test.py::test_filtering_by_file_or_path test_storage_azure_blob_storage/test.py::test_format_detection test_storage_azure_blob_storage/test.py::test_function_signatures test_storage_azure_blob_storage/test.py::test_hive_partitioning_with_all_parameters test_storage_azure_blob_storage/test.py::test_hive_partitioning_with_one_parameter test_storage_azure_blob_storage/test.py::test_hive_partitioning_without_setting test_storage_azure_blob_storage/test.py::test_insert_create_new_file test_storage_azure_blob_storage/test.py::test_insert_with_path_with_globs test_storage_azure_blob_storage/test.py::test_overwrite test_storage_azure_blob_storage/test.py::test_parallel_read test_storage_azure_blob_storage/test.py::test_partition_by test_storage_azure_blob_storage/test.py::test_partition_by_const_column test_storage_azure_blob_storage/test.py::test_partition_by_string_column test_storage_azure_blob_storage/test.py::test_partition_by_tf test_storage_azure_blob_storage/test.py::test_put_get_with_globs test_storage_azure_blob_storage/test.py::test_put_get_with_globs_tf test_storage_azure_blob_storage/test.py::test_read_from_not_existing_container test_storage_azure_blob_storage/test.py::test_read_subcolumn_time test_storage_azure_blob_storage/test.py::test_read_subcolumns test_storage_azure_blob_storage/test.py::test_respect_object_existence_on_partitioned_write test_storage_azure_blob_storage/test.py::test_schema_inference_cache test_storage_azure_blob_storage/test.py::test_schema_inference_from_globs test_storage_azure_blob_storage/test.py::test_schema_inference_from_globs_tf test_storage_azure_blob_storage/test.py::test_schema_inference_no_globs test_storage_azure_blob_storage/test.py::test_schema_inference_no_globs_tf test_storage_azure_blob_storage/test.py::test_simple_read_write test_storage_azure_blob_storage/test.py::test_simple_write_account_string test_storage_azure_blob_storage/test.py::test_simple_write_account_string_table_function test_storage_azure_blob_storage/test.py::test_simple_write_connection_string test_storage_azure_blob_storage/test.py::test_simple_write_connection_string_table_function test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_1 test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_1_table_function test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_2 test_storage_azure_blob_storage/test.py::test_simple_write_named_collection_2_table_function test_storage_azure_blob_storage/test.py::test_size_virtual_column 'test_storage_azure_blob_storage/test.py::test_storage_azure_get_gzip[bin]' 'test_storage_azure_blob_storage/test.py::test_storage_azure_get_gzip[gz]' test_storage_azure_blob_storage/test.py::test_truncate test_storage_azure_blob_storage/test.py::test_union_schema_inference_mode test_storage_azure_blob_storage/test.py::test_write_to_globbed_partitioned_path 'test_storage_mongodb_legacy/test.py::test_arrays[False]' 'test_storage_mongodb_legacy/test.py::test_auth_source[False]' 'test_storage_mongodb_legacy/test.py::test_complex_data_type[False]' 'test_storage_mongodb_legacy/test.py::test_incorrect_data_type[False]' 'test_storage_mongodb_legacy/test.py::test_missing_columns[False]' 'test_storage_mongodb_legacy/test.py::test_no_credentials[False]' 'test_storage_mongodb_legacy/test.py::test_predefined_connection_configuration[False]' 'test_storage_mongodb_legacy/test.py::test_secure_connection[True]' 'test_storage_mongodb_legacy/test.py::test_simple_insert_select[False]' 'test_storage_mongodb_legacy/test.py::test_simple_select[False]' 'test_storage_mongodb_legacy/test.py::test_simple_select_from_view[False]' 'test_storage_mongodb_legacy/test.py::test_uuid[False]' test_storage_mysql/test.py::test_binary_type test_storage_mysql/test.py::test_enum_type test_storage_mysql/test.py::test_external_settings test_storage_mysql/test.py::test_insert_on_duplicate_select test_storage_mysql/test.py::test_insert_select test_storage_mysql/test.py::test_joins test_storage_mysql/test.py::test_many_connections test_storage_mysql/test.py::test_mysql_in test_storage_mysql/test.py::test_mysql_null test_storage_mysql/test.py::test_mysql_point test_storage_mysql/test.py::test_predefined_connection_configuration test_storage_mysql/test.py::test_replace_select test_storage_mysql/test.py::test_schema_inference test_storage_mysql/test.py::test_settings test_storage_mysql/test.py::test_settings_connection_wait_timeout test_storage_mysql/test.py::test_table_function test_storage_mysql/test.py::test_where test_storage_policies/test.py::test_storage_policy_configuration_change test_storage_postgresql/test.py::test_auto_close_connection test_storage_postgresql/test.py::test_concurrent_queries test_storage_postgresql/test.py::test_datetime64 test_storage_postgresql/test.py::test_datetime_with_timezone test_storage_postgresql/test.py::test_filter_pushdown -vvv" altinityinfra/integration-tests-runner:cd6390247eca ' returned non-zero exit status 1.